using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DalEx
{
    public class DbZoneEx : Dal.DbZoneDal
    {
        public static Model.DbZone GetModel(string strQuery)
        {
            Model.DbZone dbZone = null;
            DataSet ds = Dal.DbZoneDal.Select(strQuery);
            if (SqlHelper.HasRow(ds))
            {
                dbZone = new Model.DbZone(ds.Tables[0].Rows[0]);
            }
            return dbZone;
        }
        public static DataSet GetZoneList(string strCountryName)
        {
            DataSet ds = SqlHelper.Select("select * from dbzone where countryid in (select Cid from dbCountry where Country='" + strCountryName + "')");
            return ds;
        }
    }
}
